﻿

var readyJSON = [
{ accountcode: "PL02010000", exchangerate: true, description: "Global Sales", datarow: true, index: 1,
    internalsales: {
        add: false,
        entity: 'All',
        fields: ['BA_SI01010201', 'BA_SI01030201', 'BA_SI01040101', 'BA_SI01050201', 'BA_SI01060201']
    }
},
{ accountcode: "PL02010101-1", unit: "#T#", exchangerate: false,
    internalsales: {
        entity: 'All',
        convertT: "RBNW",
        fields: ['QTY_SI01010201'],
        exchangerate: false,
        add: false
    }, convertT: "RBNW", description: "Tonnages (Head Products Manufactured)", datarow: true, index: 0
},
{ accountcode: "PL02010101-2", unit: "#T#", exchangerate: false, description: "Tonnages (First Products Manufactured)", convertT: "RBNW", datarow: true, index: 0 },
{ accountcode: "PL02010102", description: "Sales (All manufactured products)", datarow: true, index: 0, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL02010102-1", "PL02010102-2"],
        equ: "+"
    }
}]
},
{ accountcode: "PL02010102-1", exchangerate: true, description: "Sales (Head Products products)", datarow: true, index: 0,
    internalsales: {
        entity: 'All',
        fields: ['BA_SI01010201'],
        add: false
    }
},
{ accountcode: "PL02010102-2", exchangerate: true, description: "Sales (First Products products)", datarow: true, index: 0 },
{ accountcode: "PL02010103", exchangerate: true, description: "SBEW Cost", datarow: true, index: 0 },
{ accountcode: "PL02010104", exchangerate: true, description: "VC - Manufactured products", datarow: true, index: 0, internalsales: {
    entity: 'All',
    fields: ['BA_SI01010201'],
    add: true
}
},
{ accountcode: "PL02010105", description: "VM - Manufactured products", datarow: true, index: 0, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL02010102", "PL02010103", "PL02010104"],
        equ: "+"
    }
}]
},
{ accountcode: "PL02010106", description: "VM / Sales", datarow: true, index: 3, exchangerate: false, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL02010105", "PL02010102"], addition: "{0}*100",
        equ: "/"
    }
}], digits: 1, unit: "%"
},

{ accountcode: "Control", description: "PL02010103=SB0201000", controlrow: true, Process: [
 { Field: "All",
     Exp: {
         mode: "search",
         fields: ["PL02010103", "Refrence&R_Actual_SBEW&SB0201000"],
         equ: "-"
     }//from Flash input- volume excluding first products
 }]
},
{ emptyrow: true, description: "" },
{ accountcode: "PL02010201-1", unit: "#T#", exchangerate: false, convertT: "RBNW", description: "Tonnages  (Head Products Traded)", style: "green_loading", datarow: true, index: 0 },
{ accountcode: "PL02010201-2", unit: "#T#", exchangerate: false, convertT: "RBNW", description: "Tonnages (First Products Traded)", style: "green_loading", datarow: true, index: 0 },
{ accountcode: "PL02010202", description: "Sales  (All Traded Products)", datarow: true, index: 0, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL020102020-1", "PL020102020-2"],
        equ: "+"
    }
}]
},
{ accountcode: "PL020102020-1", exchangerate: true, description: "Sales (Head Products Traded)", style: "green_loading", datarow: true, index: 0 },
{ accountcode: "PL020102020-2", exchangerate: true, description: "Sales (First Products Traded)", style: "green_loading", datarow: true, index: 0 },
{ accountcode: "PL02010203", exchangerate: true, description: "SBEW Cost", style: "green_loading", datarow: true, index: 0 },
{ accountcode: "PL02010204", exchangerate: true, description: "VC - Traded Products", datarow: true, index: 0 },
{ accountcode: "PL02010205", description: "VM - Traded Products", datarow: true, index: 0, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL02010202", "PL02010203", "PL02010204"],
        equ: "+"
    }
}]
},
{ emptyrow: true, description: "" },
{ accountcode: "PL02010300", description: "Sales + VM-Traded Products", datarow: true, index: 0, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL02010102", "PL02010205"],
        equ: "+"
    }
}]
},
{ emptyrow: true, description: "" },
{ accountcode: "PL02010400", exchangerate: true, internalsales: { entity: 'All', fields: ['BA_SI01040101'] }, description: "Sales - Commission income", datarow: true, index: 0 },
{ emptyrow: true, description: "" },
{ accountcode: "PL02010500", exchangerate: true, internalsales: { entity: 'All', fields: ['BA_SI01030201'] }, description: "Sales - Services", datarow: true, index: 0 },
{ emptyrow: true, description: "" },
{ accountcode: "PL02010600", description: "VM-Total", datarow: true, index: 0, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL02010105", "PL02010205", "PL02010400", "PL02010500"],
        equ: "+"
    }
}]
},
{ emptyrow: true, description: "" },
{ accountcode: "PL02020101", exchangerate: true, description: "Fixed Operating Costs - Net", datarow: true, index: 0,
    internalsales: {
        entity: 'All',
        fields: ['BA_SI01040101'],
        add: true
    }
},
{ accountcode: "PL02020102", exchangerate: true, description: "Fixed Operating Costs - Gross Cost", datarow: true, index: 0,
    internalsales: {
        entity: 'All',
        fields: ['BA_SI01040101'],
        add: true
    }
},
{ accountcode: "PL02020103", description: "Fixed Operating Costs - Stock movement", datarow: true, index: 0, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL02020101", "PL02020102"],
        equ: "-"
    }
}]
},
{ emptyrow: true, description: "" },
{ accountcode: "PL02030101", description: "Commercial Contribution (CC)", datarow: true, index: 0, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL02010105", "PL02010205", "PL02020101", "PL02010400", "PL02010500"],
        equ: "+"
    }
}], ProcessTODO: "=PL02010105+PL02010205+PL02020101"
},
{ accountcode: "PL02030102", description: "CC / (Sales + VM Traded Products)", datarow: true, index: 0, exchangerate: false, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL02030101", "PL02010300"], addition: "{0}*100",
        equ: "/"
    }
}], ProcessTODO: "=PL02030101/PL02010300", digits: 1, unit: "%"
},
{ emptyrow: true, description: "" },
{ accountcode: "PL02020201", exchangerate: true, description: "Operating depreciation - Net", datarow: true, index: 0 },
{ accountcode: "PL02020202", exchangerate: true, description: "Operating depreciation - Gross", datarow: true, index: 0 },
{ accountcode: "PL02020203", description: "Operating depreciation - Stock movement", datarow: true, index: 0, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL02020201", "PL02020202"],
        equ: "-"
    }
}], ProcessTODO: "=PL02020201-PL02020202"
},
{ emptyrow: true, description: "" },
{ accountcode: "PL02040101", description: "Commercial Margin (CM)", datarow: true, index: 0, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL02030101", "PL02020201"],
        equ: "+"
    }
}]
},
{ accountcode: "PL02040102", description: "CM / (Sales + VM Traded Products)", datarow: true, index: 0, exchangerate: false, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL02040101", "PL02010300"], addition: "{0}*100",
        equ: "/"
    }
}], digits: 1, unit: "%"
},
{ emptyrow: true, description: "" },
{ accountcode: "PL02020104", exchangerate: true, description: "Admin. Excl. Depreciation - Net", datarow: true, index: 0,
    internalsales: {
        entity: 'All',
        fields: ['BA_SI01030201'],
        add: true
    }
},
{ accountcode: "PL02020105", exchangerate: true, description: "Admin. Excl. Depreciation - Gross", datarow: true, index: 0,
    internalsales: {
        entity: 'All',
        fields: ['BA_SI01030201'],
        add: true
    }
},
{ accountcode: "PL02020106", description: "Admin. Excl. Depreciation - Cycle movement", datarow: true, index: 0, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL02020104", "PL02020105"],
        equ: "-"
    }
}], ProcessTODO: "Calculate=PL02020105-PL02020104"
},
{ emptyrow: true, description: "" },
{ accountcode: "PL02020107", exchangerate: true, description: "R&D Excl. Depreciation - Net", datarow: true, index: 0 },
{ accountcode: "PL02020108", exchangerate: true, description: "R&D. Excl. Depreciation - Gross", datarow: true, index: 0 },
{ accountcode: "PL02020109", description: "R&D Excl. Depreciation - Cycle movement", datarow: true, index: 0, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL02020107", "PL02020108"],
        equ: "-"
    }
}]
},
{ emptyrow: true, description: "" },
{ accountcode: "PL02050101", description: "Economic EBITDA", datarow: true, index: 0, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL02030101", "PL02020104", "PL02020107"],
        equ: "+"
    }
}]
},
{ accountcode: "PL02050102", description: "Economic EBITDA  / (Sales + VM Traded Products) (%)", datarow: true, index: 0, exchangerate: false, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL02050101", "PL02010300"], addition: "{0}*100",
        equ: "/"
    }
}], ProcessTODO: "Calculate:=PL02050101 / PL02010300", digits: 1, unit: "%"
},
{ emptyrow: true, description: "" },
{ accountcode: "PL02020204", exchangerate: true, description: "Depreciation - Admin (gross)", datarow: true, index: 0 },
{ accountcode: "PL02020205", exchangerate: true, description: "Depreciation - R&D (gross)", datarow: true, index: 0 },
{ emptyrow: true, description: "" },
{ accountcode: "PL02020206", description: "Depreciation ALL - Net", datarow: true, index: 0, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL02020201", "PL02020204", "PL02020205"],
        equ: "+"
    }
}], ProcessTODO: "=PL02020201+PL02020204+PL02020205"
},
{ accountcode: "PL02020207", description: "Depreciation ALL - Gross", datarow: true, index: 0, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL02020202", "PL02020204", "PL02020205"],
        equ: "+"
    }
}], ProcessTODO: "calculate:='Operating depreciation - Gross'+'Depreciation - Admin'+'Depreciation - R&D'"
},
{ accountcode: "PL02020208", description: "Depreciation ALL - Stock movement", datarow: true, index: 0, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL02020206", "PL02020207"],
        equ: "-"
    }
}], ProcessTODO: "calculate:=PL02020207-PL02020206"
},
{ emptyrow: true, description: "" },
{ accountcode: "PL02060101", description: "Operating profit (OP)", datarow: true, index: 0, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL02050101", "PL02020206"],
        equ: "+"
    }
}], ProcessTODO: "calculate:=PL02050101+PL02020206"
},
{ accountcode: "PL02060102", description: "OP / (Sales + VM Traded Products) (%)", datarow: true, index: 0, exchangerate: false, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL02060101", "PL02010300"], addition: "{0}*100",
        equ: "/"
    }
}], ProcessTODO: "calculate:=PL02060101 / PL02010300", digits: 1, unit: "%"
},
{ emptyrow: true, description: "" },
{ accountcode: "PL02020500", description: "Transitions gains & charges", datarow: true, index: 0, bold: true, Process: [{
    Field: "All",
    Exp: {
        mode: "to",
        start: "PL02020501",
        end: "PL02020506",
        equ: "+"
    }
}], ProcessTODO: "Sum"
},
{ accountcode: "PL02020501", exchangerate: true, description: "Sales -Others", datarow: true, index: 0 },
{ accountcode: "PL02020502", exchangerate: true, description: "Cost - Other sales", datarow: true, index: 0, ProcessTODO: "data should be from F report" },
{ accountcode: "PL02020503", exchangerate: true, description: "Resin", datarow: true, index: 0, ProcessTODO: "data should be from F report" },
{ accountcode: "PL02020504", exchangerate: true, description: "Income tax adjustments", datarow: true, index: 0, ProcessTODO: "data should be from F report" },
{ accountcode: "PL02020505", exchangerate: true, description: "FI-CO variance (depreciation gap)", datarow: true, index: 0 },
{ accountcode: "PL02020506", exchangerate: true, description: "FI-CO Other variance", datarow: true, index: 0 },
{ emptyrow: true, description: "" },
{ accountcode: "PL02020300", description: "Other Operating Gains & Charges", datarow: true, index: 0, bold: true, Process: [{
    Field: "All",
    Exp: {
        mode: "to",
        start: "PL02020301",
        end: "PL02020309",
        equ: "+"
    }
}]
},
{ accountcode: "PL02020301", exchangerate: true, description: "Sales - Disposal of FA", datarow: true, index: 0 },
{ accountcode: "PL02020302", exchangerate: true, description: "Cost of FA disposal-Gross book value", datarow: true, index: 0, ProcessTODO: "data should be from F report" },
{ accountcode: "PL02020310", exchangerate: true, description: "Cost of FA disposal- Reversal of cumulative depreciation", datarow: true, index: 0 },
{ accountcode: "PL02020303", exchangerate: true, description: "Sales - Scrap", datarow: true, index: 0 },
{ accountcode: "PL02020304", exchangerate: true, description: "Cost - Scrap", datarow: true, index: 0, ProcessTODO: "data should be from F report" },
{ accountcode: "PL02020305", exchangerate: true, description: "Impairement in Fixed Assets & Goodwill", datarow: true, index: 0, ProcessTODO: "data should be from F report" },
{ accountcode: "PL02020306", exchangerate: true, description: "Restructuration & Litigation", datarow: true, index: 0, ProcessTODO: "data should be from F report" },
{ accountcode: "PL02020307", exchangerate: true, description: "Hedging (floating gain &loss)", datarow: true, index: 0, ProcessTODO: "data should be from F report" },
{ accountcode: "PL02020308", exchangerate: true, description: "Other Provision", datarow: true, index: 0, ProcessTODO: "data should be from F report" },
{ accountcode: "PL02020309", exchangerate: true, description: "Other operating Expenses & Income", datarow: true, index: 0, ProcessTODO: "data should be from F report" },

{ emptyrow: true, description: "" },
{ accountcode: "PL02070101", description: "Operating Income", datarow: true, index: 0, bold: true, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL02060101", "PL02020500", "PL02020300"],
        equ: "+"
    }
}], ProcessTODO: "=PL02060101+PL02020500+PL02020300"
},
{ accountcode: "PL02070102", description: "Operating Income/ (sales + VM Traded Products) %", datarow: true, index: 0, exchangerate: false, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL02070101", "PL02010300"], addition: "{0}*100",
        equ: "/"
    }
}], ProcessTODO: "=PL02070101/  PL02010300", digits: 1, unit: "%"
},
{ emptyrow: true, description: "" },
{ accountcode: "PL02020400", description: "Financial", datarow: true, index: 0, bold: true, Process: [{
    Field: "All",
    Exp: {
        mode: "to",
        start: "PL02020401",
        end: "PL02020406",
        equ: "+"
    }
}], ProcessTODO: "sum PL02020401 to PL02020406"
},
{ accountcode: "PL02020401", exchangerate: true, description: "Interest expense", datarow: true, index: 0,
    internalsales: {
        entity: 'All',
        fields: ['BA_SI01060201'],
        add: true
    }
},
{ accountcode: "PL02020402", exchangerate: true, description: "Interest income", datarow: true, index: 0,
    internalsales: {
        entity: 'All',
        fields: ['BA_SI01060201'],
        add: false
    }
},
{ accountcode: "PL02020403", exchangerate: true, description: "Actualized FX gain/loss - cash & debt", datarow: true, index: 0 },
{ accountcode: "PL02020404", exchangerate: true, description: "Actualized FX gain/loss - excluding cash & debt", datarow: true, index: 0 },
{ accountcode: "PL02020405", exchangerate: true, description: "Floating FX gain/loss - cash & debt", datarow: true, index: 0 },
{ accountcode: "PL02020406", exchangerate: true, description: "Floating FX gain/loss - excluding cash & debt", datarow: true, index: 0 },
{ emptyrow: true, description: "" },
{ accountcode: "PL02020600", exchangerate: true, description: "Corporate income taxes", datarow: true, index: 0, bold: true },
{ emptyrow: true, description: "" },
{ accountcode: "PL02080101", description: "Net Income", datarow: true, index: 0, bold: true, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL02070101", "PL02020400", "PL02020600"],
        equ: "+"
    }
}]
},
{ accountcode: "PL02080102", description: "Net Income / (Sales + VM Traded Products) (%)", datarow: true, index: 0, exchangerate: false, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL02080101", "PL02010300"], addition: "{0}*100",
        equ: "/"
    }
}], digits: 1, unit: "%"
},
{ emptyrow: true, description: "" },
{ accountcode: "PL02090101", description: "Net Income Before Amort. & Depreciation", datarow: true, index: 0, bold: true, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL02080101", "PL02020206", "PL02020505", "PL02020305", "PL02020503"],
        equ: "-"
    }
}]
},
{ emptyrow: true, description: "" }
];
